package com.ttg.model.pojo;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import java.io.Serializable;
import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.HashMap;
import java.util.Map;

@Data
@TableName(value = "tbl_public_primitive")
public class PublicPrimitive implements Serializable {


    private static final long serialVersionUID = -1178046686283947240L;
    /**
     * 主键
     */
    @TableId(value = "id" , type = IdType.AUTO)
    private Long id;

    /**
     * 客户号
     */
    @TableField(value = "cst_id")
    private Long cstId;


    /**
     * 银行账号
     */
    @TableField(value = "bank_account")
    private String bankAccount;


    /**
     * 账户状态
     */
    @TableField(value = "account_status")
    private Integer accountStatus;


    /**
     * 商户名称
     */
    @TableField(value = "account_name")
    private String accountName;


    /**
     * 法人姓名
     */
    @TableField(value = "legal_person_name")
    private String legalPersonName;


    /**
     * 身份证号
     */
    @TableField(value = "id_number")
    private String idNumber;


    /**
     * 年龄
     */
    @TableField(value = "age")
    private Integer age;


    /**
     * 性别
     */
    @TableField(value = "sex")
    private Integer sex;


    /**
     * 开户行
     */
    @TableField(value = "opening_bank")
    private String openingBank;


    /**
     * 所属地区
     */
    @TableField(value = "address")
    private String address;


    /**
     * 客户经理
     */
    @TableField(value = "customer_manager_name")
    private String customerManagerName;


    /**
     * 客户经理ID
     */
    @TableField(value = "customer_manager_id")
    private String customerManagerId;


    /**
     * 管控人
     */
    @TableField(value = "control_personnel")
    private String controlPersonnel;


    /**
     * 时点余额
     */
//    @TableField(value = "amount")
//    private BigDecimal amount;


    /**
     * 收单商户 0否 1是
     */
    @TableField(value = "acquiring_merchant")
    private Integer acquiringMerchant;


    /**
     * 当日交易金额
     */
    @TableField(value = "day_transaction_amount")
    private BigDecimal dayTransactionAmount;


    /**
     * 当周交易金额
     */
    @TableField(value = "weeks_transaction_amount")
    private BigDecimal weeksTransactionAmount;


    /**
     * 当月交易金额
     */
    @TableField(value = "month_transaction_amount")
    private BigDecimal monthTransactionAmount;


    /**
     * 当季交易金额
     */
    @TableField(value = "quarter_transaction_amount")
    private BigDecimal quarterTransactionAmount;


    /**
     * 当年交易金额
     */
    @TableField(value = "year_transaction_amount")
    private BigDecimal yearTransactionAmount;


    /**
     * 当日交易笔数
     */
    @TableField(value = "day_transaction_stroke_count")
    private Integer dayTransactionStrokeCount;


    /**
     * 当周交易笔数
     */
    @TableField(value = "weeks_transaction_stroke_count")
    private Integer weeksTransactionStrokeCount;


    /**
     * 当月交易笔数
     */
    @TableField(value = "month_transaction_stroke_count")
    private Integer monthTransactionStrokeCount;


    /**
     * 当季交易笔数
     */
    @TableField(value = "quarter_transaction_stroke_count")
    private Integer quarterTransactionStrokeCount;


    /**
     * 当年交易笔数
     */
    @TableField(value = "year_transaction_stroke_count")
    private Integer yearTransactionStrokeCount;


    /**
     * 商户手续费金额
     */
    @TableField(value = "merchant_commission_amount")
    private BigDecimal merchantCommissionAmount;


    /**
     * 商户当周手续费金额
     */
    @TableField(value = "weeks_merchant_commission_amount")
    private BigDecimal weeksMerchantCommissionAmount;


    /**
     * 商户当月手续费金额
     */
    @TableField(value = "month_merchant_commission_amount")
    private BigDecimal monthMerchantCommissionAmount;


    /**
     * 商户当季手续费金额
     */
    @TableField(value = "quarter_merchant_commission_amount")
    private BigDecimal quarterMerchantCommissionAmount;


    /**
     * 商户当年手续费金额
     */
    @TableField(value = "year_merchant_commission_amount")
    private BigDecimal yearMerchantCommissionAmount;


    /**
     * 商户当日补贴费金额
     */
    @TableField(value = "day_merchant_subsidy_amount")
    private BigDecimal dayMerchantSubsidyAmount;


    /**
     * 商户当周补贴费金额
     */
    @TableField(value = "weeks_merchant_subsidy_amount")
    private BigDecimal weeksMerchantSubsidyAmount;


    /**
     * 商户当月补贴费金额
     */
    @TableField(value = "month_merchant_subsidy_amount")
    private BigDecimal monthMerchantSubsidyAmount;


    /**
     * 商户当季补贴费金额
     */
    @TableField(value = "quarter_merchant_subsidy_amount")
    private BigDecimal quarterMerchantSubsidyAmount;


    /**
     * 商户当年补贴费金额
     */
    @TableField(value = "year_merchant_subsidy_amount")
    private BigDecimal yearMerchantSubsidyAmount;


    /**
     * 更新时间
     */
    @TableField(value = "update_time")
    private LocalDateTime updateTime;


    /**
     * 开户时间
     */
    @TableField(value = "account_opening_time")
    private LocalDateTime accountOpeningTime;


    /**
     * 商户编号
     */
    @TableField(value = "mct_no")
    private String mctNo;

}

